package cn.com.yusys.yusp.admin.domain;

import cn.com.yusys.yusp.commons.excel.annotation.ExcelColumn;
import cn.com.yusys.yusp.commons.excel.annotation.ExcelName;
import com.fasterxml.jackson.annotation.JsonFormat;
import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;
@ExcelName(value = "网格员业绩排名表", sheet = "网格员业绩排名表")
public class GridMemberPerformanceRankingPojo {
    @ExcelColumn(title = "查询日期", index =0)
    @DateTimeFormat(pattern="yyyy-MM-dd")
    @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd")
    private Date etlDt;
    @ExcelColumn(title = "机构名称", index = 1)
    private String gridName;
    @ExcelColumn(title = "网格名称", index = 2)
    private String secondGridName;
    @ExcelColumn(title = "档案号", index = 3)
    private String userNo;
    @ExcelColumn(title = "网格员姓名", index = 4)
    private String userName;
    @ExcelColumn(title ="全部建档客户数",index = 5)
    private String documentCustNum;
    @ExcelColumn(title = "全部建档客户数全行排名",index = 6)
    private String rank1;
    @ExcelColumn(title = "转化数",index = 7)
    private String converNum;
    @ExcelColumn(title = "转化数全行排名",index = 8)
    private String rank2;
    @ExcelColumn(title = "存款增量",index = 9)
    private String depBalAdd;
    @ExcelColumn(title = "存款增量全行排名",index = 10)
    private String rank3;
    @ExcelColumn(title = "贷款增量",index = 11)
    private String loanBalAdd;
    @ExcelColumn(title = "贷款增量全行排名",index = 12)
    private String rank4;
    @ExcelColumn(title = "当月建档客户数",index = 13)
    private String documentCustNumM;
    @ExcelColumn(title = "当月建档客户数全行排名",index = 14)
    private String rank5;
    @ExcelColumn(title = "当月转化数",index = 15)
    private String converNumM;
    @ExcelColumn(title = "当月转化数全行排名",index = 16)
    private String rank6;

    public Date getEtlDt() {
        return etlDt;
    }

    public void setEtlDt(Date etlDt) {
        this.etlDt = etlDt;
    }

    public String getGridName() {
        return gridName;
    }

    public void setGridName(String gridName) {
        this.gridName = gridName;
    }

    public String getSecondGridName() {
        return secondGridName;
    }

    public void setSecondGridName(String secondGridName) {
        this.secondGridName = secondGridName;
    }

    public String getUserNo() {
        return userNo;
    }

    public void setUserNo(String userNo) {
        this.userNo = userNo;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getDocumentCustNum() {
        return documentCustNum;
    }

    public void setDocumentCustNum(String documentCustNum) {
        this.documentCustNum = documentCustNum;
    }

    public String getRank1() {
        return rank1;
    }

    public void setRank1(String rank1) {
        this.rank1 = rank1;
    }

    public String getConverNum() {
        return converNum;
    }

    public void setConverNum(String converNum) {
        this.converNum = converNum;
    }

    public String getRank2() {
        return rank2;
    }

    public void setRank2(String rank2) {
        this.rank2 = rank2;
    }

    public String getDepBalAdd() {
        return depBalAdd;
    }

    public void setDepBalAdd(String depBalAdd) {
        this.depBalAdd = depBalAdd;
    }

    public String getRank3() {
        return rank3;
    }

    public void setRank3(String rank3) {
        this.rank3 = rank3;
    }

    public String getLoanBalAdd() {
        return loanBalAdd;
    }

    public void setLoanBalAdd(String loanBalAdd) {
        this.loanBalAdd = loanBalAdd;
    }

    public String getRank4() {
        return rank4;
    }

    public void setRank4(String rank4) {
        this.rank4 = rank4;
    }

    public String getDocumentCustNumM() {
        return documentCustNumM;
    }

    public void setDocumentCustNumM(String documentCustNumM) {
        this.documentCustNumM = documentCustNumM;
    }

    public String getRank5() {
        return rank5;
    }

    public void setRank5(String rank5) {
        this.rank5 = rank5;
    }

    public String getConverNumM() {
        return converNumM;
    }

    public void setConverNumM(String converNumM) {
        this.converNumM = converNumM;
    }

    public String getRank6() {
        return rank6;
    }

    public void setRank6(String rank6) {
        this.rank6 = rank6;
    }
}
